Creating final retention invoices
The preferred method to request final payment for retention is to print a progress bill report.
Important! Because retention has been included in the previous progress billing applications, you must credit the retention amount before you can create a separate retention invoice. Follow the six parts of this procedure to release retention, create a retention credit, apply the credit, and create your retention invoice.
- Open 3-7 Progress Billing.
- Open the last application with a Status 3-Posted for the job, and click Next.
- At the message, Reminder: A new record will be created and this one will become Closed. Do you want to continue? click Yes.
- Note the amount in the Retention box.
- From the Update menu, select Release Retention.
- At the message, This will reset all retention rates to zero and recalculate the application. Do you want to continue? click Yes.
-
On the Calculate grid, select a method to calculate the Progress Billing, and then click Calculate.
The Retention amount becomes the Invoice Amount.
- Click File > Save.
- From the File menu, select Recall.
- From the Options menu, select Submit Application.
- From the File menu, select Print.
- Print the appropriate Progress Billing report, reports 21—42 and send this report to your customer to show the retention amount is now due.
- Close the 3-7 Report Printing window.
Note: The final application remains in Submitted status because there is not an invoice amount to post.
- Open 3-5 Jobs (Accounts Receivable), and then display the job.
- In the Terms section of the window, clear the Retention Rate.
- From the Update menu, select Recalculate Retention.
- On the Recalculate Retention window, enter the New Due Date for Invoices, and then select the appropriate Recalculation option.
- Click OK.
- To the message to confirm the number of open invoices found, click OK.
- Click > .
- On 3-5 Jobs (Accounts Receivable), click Invoices, and then review the Net Due amount to verify that the retention has been released.
Create a retention credit invoice and use the amount of retention due as the Price of the credit.
-
Open 3-2 Receivable Invoices/Credits, and then:
- In the Invoice# text box, enter the credit invoice number.
- In the Date text box, enter the date of the invoice.
- In the Job text box, enter the job number.
- If the job uses phases, enter the phase number in the Phase text box.
- In the Description text box, enter a brief statement about the invoice.
- In the Due Date text box, enter the invoice due date.
- In the Discount Date text box, enter the due date by which payment must be received for the discount to apply.
- In the Status list, select the invoice status.
- In the Type list, select the invoice type.
-
In the grid:
- In the Description cell, enter a brief statement about the item.
- In the Quantity cell, enter the quantity of items as a negative amount.
- In the Price cell, enter the amount of the retention due.
- In the Account cell, enter the ledger account number.
- Repeat step 2 for each item.
- Click > .
In 3-3-1 Cash Receipts apply the credit to all open retention.
-
Apply the retention credit invoice created to all open retention invoices.
Note: For detailed instructions on applying a credit to open invoices see the link below.
-
Open 3-3-1 Cash Receipts, and then:
- In the Account box, type the ledger account number for the cash account.
- In the Deposit# box, type the deposit number.
- In the Date box, type the deposit date.
- In the Description box, type a brief statement about the transaction.
-
Do one of the following:
- In the Client box, type the client number.
- In the Job box, type the job number.
-
Do one of the following:
- Click the Contract Invoices tab.
- Click the Service Invoices tab.
- Click the Display Invoices button.
- In the grid:
- In the Credit cell of the original invoice, type the amount as a positive number.
- In the Credit cell of the credit invoice, type the amount as a negative number.
Important! The amounts in the Credit column must balance to zero.
- Repeat step 6 for each credit you want to apply.
- Click File > Save.
Create an invoice using the amount of retention due as the Price of the invoice.
- Open 3-2 Receivable Invoices/Credits, and then:
- In the Invoice# box, type the invoice number.
- In the Date box, enter the date of the invoice.
- In the Job box, type the job number.
- If the job uses phases, type the phase number in the Phase box.
- In the Description box, type a brief statement about the invoice.
- In the Due Date box, enter the invoice due date.
- In the Discount Date text box, type the due date by which you must receive payment for the client to receive the discount.
- From the Status list, select the invoice status.
In the Type list, click the invoice type.
Note: Select an Invoice type Memo if you do not want the transaction to effect the job balances
-
In the grid:
- In the Description cell, type a brief statement about the item.
- In the Quantity cell, type the quantity of items.
- In the Price cell, type the amount of retention due as the Price of the invoice.
- In the Account cell, enter the ledger account number.
- Repeat step 2 for each item.
- Click File > Save.
- Open 3-4 Statements.
- Select the 21-Job Statements report.
- In the Job# box, type the job number.
- Select the Include Paid Invoices checkbox.
- Select the Include Payment History checkbox.
- From the File menu, select Print.
- On the Statement Variables window, type the Statement Date, and click OK.
- Your statement details all outstanding amounts due, including the retention invoice.
- Close the 3-4 Report Printing window.